Page 1

LILAC Document Help

Garbage Collect or Clean up

Database size, a34 data structure, and computer hardware technology each contribute to Garbage Collect and Clean Up procedures to maintain a manangable database.

Garbage Collect is broard approach typically used across the board at required intervals.

The garbage collect ulitity enables the user to select specific sales, purchase, and transfer documents to be removed from the database prior to a desired date. Removed historical totals from garbage collected documents will remain as figures within the balance ledger, ie stock, debtors, and creditors within the trading ledger.

Notes:
Garbage Period - BALANCE, TRADING, INVENTORY, WIP Ledger Entries. The selection of a period in this field will remove details prior to the desired period, and provide an opening balance.

Debtor Period - DEBTORS Ledger Entries. The selection of a period in this field will remove details prior to the desired period, and provide an opening balance.

Payroll Garbage - PAYROLL Ledger Entries. Not typically garbage collected.

The Invoice field is not typically garbage collected unless desired or very out dated.

The Clean Up process is typically directed at selected areas. Clean Up is directed at visual presentation documents such as historical Sales Order documents, the removal of which does not affect the subsequent Invoice document.

Each of the following reports can be applied up to a selected date.

Bank Reconcilliation - older than this date.
Creditor Payments - older than this date.
Creditor Statements - older than this date.
CRM History - older than this date.
Debtor Receipts - older than this date.
Debtor Statements - older than this date.
Purchase Orders - older than this date.
Sales Orders - older than this date.